.....Even if there is water, I know that the water from my house is OK. Not always true elsewhere.....
The longer you RV you will get that it is not where the water comes from.
An RV Fresh water tank is not your house plumbing. It is a non-sterilzed "holding tank".
Doesn't matter what water you put in it it WILL get spunky. It is the perfect breeding ground for bacteria because it IS a holding tank.
Keeping your tanks always full never removes the sediment and bacteria.
I full time and I completely drain the fresh tank once a week. Add water and drain again. Only put 1/3 in for traveling. If going where there are no hookups I will fill up somewhere close to destination.
The argument that we drive with are gas tanks full doesn't hold water!! You are not PULLING the extra weight that is in your gas tank in your truck! :W