I think you need to carry out a feasibility study - to make a cost analysis for different water sources. Maybe it is more feasible to drill a new well nearby the homes. Also, the operational costs should be considered (pumping, possible treatment, etc). Hopefully, you will find a better local...
