Around here a deep well is 90-100 feet some a lot are less. Where my one sons home is wells average 400 feet. Location is everything. The problem with pumping water by hand is how much energy it takes to work the pump. The more you try to lift with each pump the more energy it takes. That is why on early farms around here they adapted anything they could to pump water. Wind mills any engine they had was fitted in some way to run a pump. Still a few pictures around here of them using a model A ford with a tire rim running a belt to water cattle.
I have 2 spots on this farm That most of the year water will flow from the ground on its own. if you just drive a pipe in the ground.