Possible? Sure, and a lot oft of hippie/environmentalist types in America do live that way, both in cities and in rural areas.
Is it desirable? Not necessarily. The goal is to be more efficient with water sourcing, distribution, and usage so people have more water to use, not less.