Move out of the City, get some Land, Drill a well and install a Bison hand water pump. Mine works great, the Max depth is around 350 or so feet so not going to work for all. But its the best thing I have found short of a solar pump.
http://www.bisonpumps.com/ Anyways hope this helps
MK