the majority of usage goes towards power generation (https://water.usgs.gov/edu/wateruse-total.html). urban areas consume the power, but they dont produce it. they hide their water usage in the rural areas.
Looking at that data it appears that a majority of California's water for power generation is coming from salinated sources, so at least for California the largest user of fresh water sources is still irrigation (agriculture).
Either way, the point that agriculture takes a lot more water than people watering their lawns still stands.
Either way, the point that agriculture takes a lot more water than people watering their lawns still stands.