Cloudy RV water could be caused by your water supply. Campsite water isn't usually the cleanest, and could contain sediment and other impurities. Air bubbles could also cause cloudiness in your RV's drinking water.
You can get rid of cloudiness in your RV water by testing your water and using a filtration solution based on your results.