Yah, I've never had much luck on "good water" at a campsite.. one or two maybe, but nothing I could count on.
I tried the hose filter and it leaked so much and didn't really make a big difference, so stopped using it.
If I were camping full time, I'd probably use the Brita as I use it at home exclusively.
Camping, as mentioned before, I have 3 of those 5-gal blue clear plastic bottles that I rotate with hand pump that screws on the top (they had a battery one, but too much of a hassel worrying about it).
For a 2-4 day trip, I'll take one full bottle, maybe two if I think it's going to be close. Then you just take the empty ones when I go to the market and fill it for $2, filtered and tastes decent.
If I don't use one container completely, I'll hold it in garage and next trips return fill the extra into that one. Usually it'll fill it back up... depends on usage, but he bottled water works for moi the best... sigh, as of now anyway.. heheh..
I still have the RV Hose filter, but haven't used it for 2 yrs.
I just use the bottled water for coffee, drinking etc.. If I can't hook up at the campsite, I'll bring a small 3 gal + the 8 gal i have in the TD.. 3 gal, not 5 as I can carry it back and forth from the community water spigot. Used mainly for dishes etc..
So far so good...
fun...