we are lucky in that many nearby places we camp have decent tasting water. However, I carry with me a camco water filter to use when we come across water with sediment, and also a sinktop charcoal filter for drinking water from the tank.
https://www.amazon.com/Culligan-US-EZ-4-EZ-Change-Undersink-Filtration/dp/B000NNPVUS/ref=sr_1_8?ie=UTF8&qid=1533693940&sr=8-8&keywords=culligan+water+filter
And when we get to places with hard water out comes the "waterstick" portable water softener. Small but big enough to soften around 100 gallons of water with hardness near 10 grains. If we go through more than 100 gallons, 2 liters of saturated salt water will recharge it in about 15 minutes.
The combo has worked well for us over the years.
We almost NEVER drink bottled water, just water from the tank. The exception is if we are in an area with unpleasant tasting water, then we go for bottled water.
Since neither of us is on a low sodium diet, using a water softener for drinking water isn't an issue for us. For those that it is, you can use potasium chloride instead of sodium chloride.