Here in Ireland the majority of us in the countryside have to have a well system, as there is no mains water outside of the towns.
We have a pump house that has a 240 foot deep well, they charge by the foot approx. 3Euro a foot.
The well is only about 8 inches in diameter with a submersible pump at the bottom price for that pump is around 500-600euro, we hit water at about 40 foot, the extra depth is just redundancy in case it starts to dry out.
At the top of the well is a second pump to send the water into the house, along with this is a filtration system costing around 2000 euro, there are several different types of filtration as we have "rabbit sand" in our water we have to have multiple tanks to filter out all the debris. All of this is housed in a pump house about 1 meter by 2 meters and about 10 feet high.
The advantage of all this is unlimited water free of charge, as Ireland are just starting to bring in a water charge for those on mains supply.
However there are some downsides as mentioned before if your electricity is interrupted then you have no water until the supply is restored.
You also have to have salt added to your filters every 18 months to maintain its efficiency.
There are also some unforeseen costs that unlike being on mains you will have to pay for yourself if your system breaks, for example our submersible pump recently broke, to fix it we had to drag it up 240 foot no easy feat, to replace the motor, this cost us 200 euro for a new motor. Luckily we knew a local farmer who knows how to fix things otherwise you could triple that cost for the expertise of an electrician.
I hope this helps you to make an informed decision, prices in the U.K. will most likely be different to here in RoI but I hope this has given you a good idea of prices. I would recommend you looking into a well system as nothing beats having your own fresh water supply.
All the best
Jacob