Instead of the expense of a well, have you considered rainfall collection?
My signature takes you to a permies topic on the subject.
With groundwater shortage, pollution and expense of drilling it may suit.
One trick is to have a large storage tank rather than a 200L barrel, the bigger volume allows settlement of fines and cleaning of the
water by contact with the air.