Detecting "no more flow" is actually the hard part of this project. The Arduino is millions of times faster than a human so 1 second of no flow is several million clock cycles of waiting.
Buy a sensor that's easy to attach to your hose connections. Make sure it is compatible with the voltage of your Arduino (usually 5V). Then start writing code and playing with it.