For a normal diaphragm water pump, if you have the system running and close the tap, the water between the pump and faucets is still under pressure and the pump will shut off once the set pressure is reached. The pump will then come on once the faucet is opened which lowers the pressure and triggers the pressure switch to turn on the pump. If you turn off the breaker for the pump at the switch, you will still get some water out until the pressure is all released. If you need to turn off and on an electric switch then you probably do not have a pressure system.