I've no affiliation w/above, but maybe it'd be a starting point for you.
We have a shallow well with a regular old-timey hand pump that would do in an emergency - water for flushing toilet, but would have to filter/boil to be potable. This well was replaced as a water source by a ‘deep’ well with a submersible pump that runs off electricicty so when the power goes, so goes the water until we can get the generator up & running - of course, if generator fuel runs out, we’re screwed!! This Simple Pump looks like just the thing we need to make the deep well accessible with no power - great link, thanks SO much!! I’ll be passing it on to a couple of folks.