Check out caravan water filters on eBay, not the best but 2 are sub $20 and have the standard ouch to connect garden house coupling male side nipples inclided.
Get some food grade hose and new fittings at the big green shed and run them both inline and use a low flow rate, renters delight.
I drain them spray with sanitiser and keep them in a bag in the fridge when not in use. Don't have any water data but the taste is greatly improved over straight from the tap (which is still drinkable).
Best budget and ghetto option I've found dollars for doughnuts.
Thanks, this looks like a good idea