If you want to do this yourself

1) install HAOS, running it any other way is a step towards madness

2) get a decent zigbee controller

3) https://sonoff.tech/en-uk/products/sonoff-zigbee-smart-water...

Job done, the rest is all up to taste using either sensors or public data to infer water state.