My water comes from a beck - so does everyone's round here, you can see that the original 11 farms in the dale were built on becks.
I wouldn't change it. In fact, it's one thing that puts me off buying somewhere else, having to drink mains water again.
My water comes through a string filter (for sticks, fish and mud) and a UV filter, for bacteria. It changes colour depending on how much it's rained, and can look quite brown after heavy rain. It always tastes good, no chlorine, aluminium sulphate, fluoride - which have their own various health issues.
A couple of the newer houses (ie newer than 1650s
) have had boreholes drilled, cos they are not on reliable becks. My beck has run low once, but has never run dry.