Regarding emergencies... no electricity generally. So, how about this: http://www.ezwaterwellhandpumps.com/ for approx. $169.

The only downside is that the water table needs to be relatively shallow