I assume there's no above ground water supply like a lake or river. In Hawaii, they use rain water collection, it's simple and works pretty well. If you don't get enough rain, you'll need a well. What I would do is depending on the depth of well, is put a DC pump in the well that can deliver just a few gallons per minute. Then power the pump using a direct solar panel (if possible). The idea is the pump would only run when there's sun. It would then pump the water up to a standing holding tank. You wouldn't require a battery or MPPT because the water tank is your battery. It's very simple, but will work for it's intended purpose.