AT TIny 84 Feasability

If the water sensor is just a switch, for example counting liters or gallons, and you use a Bluetooth wireless serial module to transmit the data, then that chip would be fine. Even an ATtiny13 would work.

You can bit-bang TTL serial (i.e. use software serial). Total I/O pins required = 2 if transmit only.