In case it hasn't been mentioned elsewhere in this lengthy thread, a water FILTER is NOT a water PURIFIER. The Food and Drug Administration (FDA) makes a clear distinction between the two. A filter may remove sediment and a few minerals, but filters geenrally do NOT remove the dangerous bacteria that will make you ill.
If water is not already safe to drink, it has to be PURIFIED to make it safe to drink. Look on Amazon and Ebay for water purifiers and you will see that most are made up of filtration to remove solids plus a bacteria killing stage such as ultra-violet exposure.
Purifiers, unfortunately, tend to be affordable only in low volume capacity. We use a purifier that meets FDA requirements but because it delivers only 1/2 gallon per minute we use it only for ice making and drinking water. Luckily, monthly testing of the municipal water supply here in Los Barriles always indicates that it meets all of the FDA requirements for drinking water. As a result, we use it for brushing our teeth and washing dishes, etc.
Well water test kits are available on line that can be used to take a "snapshot" of water safety if you plan to stay in one place for a while.