For whatever reason, no one I know (except me) will drink water out of the faucet. Most people get the refillable 5 gallon containers. Our filtration system provider went out of business during COVID, so we buy in refillable 2 gallon containers (and keep some none refillable ones on hand for the people who won't drink the "sink water") It does taste a tiny bit like chlorine and it is slightly cloudy, but if you wait 3-4 minutes, it's fine. IMO.
But yeah, many many people won't drink water from the faucet, whether camping or not.