Windmills are still used today for pumping water from the ground. Did some research and the top portion will cost close to $3000. Then you need the tower which ranges from $2500 to $7000 depending on the height. Now you need the shaft, pump and something to hold water.
After that you have free water forever, as long as the well doesn't go dry.