Go for it. We are also in mid-Wales and have a private water supply. Personally I think it is a plus point. The bad press that water companies get these days, the expense if you are needing to pay to water livestock, fruit, veg, poly tunnel etc.......
Ugh - that would be really restrictive.
We didn't have any issues about the water supply at all with the mortgage company when we bought ours.