I dunno if this has come up before, but hand pumps are probably a good idea for a lot of applications. When I was a kid, these were very common outside the city. Some folks even had them inside their houses. Now they are relatively rare.
On a city water system, they usually pump the water up to a high point, maybe even a water-tower (there are two big ones up the hill from me), so that it flows down without power. I dunno how long they would last if the lights go out long enough, because there is some pumping happening.
In deep-rural areas where people have wells, there is NO water when the power goes out--and the power is APT to go out anyway due to lack of grid redundancy such as exists in the city.
You can purchase models that have thread fittings on them so that you can thread a hose to them.