LM1380 water level detector, used in reverse: instead of detecting water, it detects absence of water.It uses an ac oscillator that only work submerged in water. For your application it should always be in alarm state (water detected). When the alarm goes off,
it's time to water.
PS-While your ordering supplies, don't forget to order a year's supply of chips and redbull .