It looks like you may already have a sensor programmed in this way, is that existing water sensor the one you are referencing or are you adding a new one?
If it’s that one, you would just need a notification set up for it.
A guide on creating a new notification is linked below. You could choose a Water alert notification or just Sensor Activity as the type of notification since it is programmed as sensor group 25.