Instead suggesting you any circuits, i would like to suggest you a way out for this. You may choose which one to go for.
Or you may monitor the flow of water coming out of the outlet, and give a timed feedback to the pump so that it swicthes OFF if no water comes out within the specified time from the moment the motor is swicthed ON.
Other way is to monitor the consumtion of the pump. While the water is bieng pumped, the current consumption will be approx the one marked on the motor / the motor rated for. When no water is pumped, the motor runs freely which drops the consumption which can be monitored and fed back to the circuit controlling the motor to swiicth OFF.
Cheers