Learning how to grow your own food is the only sustainable way that you are going to survive in the long term should society collapse
one manner is via fish farming and aquaphonics
Of coarse you need an effective pump — PUMP ideas
one that can be made from scratch
also you can use a pipe and some rope in a loop – ROPE Pump and threading the rope through will cause watter to rise — nice thing is its very easy to improvise and can be powered with a VAWT wint turbine vawt savonius – they have high torque compared to other designs and are self breaking and can be made with very little knowhow.