A sand pont is a hardened screened pipe tip that you drive into the ground using a fence post driver, you use couplers and galvanized water pipe, and add successive lengths as you drive them into the gound.
When you hit the water table, you use a shallow water pump to pump up the water. It's cloudy at first, but it clears after the sand in the table begins to filter the water, and clarify it. It will only provide weekend water, say for a cabin, or a small family.