nobody wants to drink water from a barrel. but such a tiny fraction of our water goes to drinking and cooking it’s almost a shame we don’t have a dual system.
we spend billions of dollars on conservation treatment and protection of our “drinking water” that we use to wash our cars or water our lawns.
CRD does pay a lot to disinfect drinking water, but "treatment" usually involves filtering water in addition to disinfection. We'll probably be forced to build/operate a massive filtration plant ($150-200 million capital cost) in a few years, either by federal decree or when the Leech watershed supply is brought online.
For dual systems, so much of the expense of water supply is in the distribution infrastructure, probably would only be economically feasible in non-urban, "off the grid" systems.
However, according to a Water Research Foundation 2019 study, there are about 300 dual water systems in the US, related particularly to reclaimed water (ie, treated sewage effluent)
In the CRD, there are limited examples of dual systems but probably farms are the only systems I can recall - what was the common farm-pond for crops/animals and the well (with disinfection and constant monitoring) for farm family consumption.