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.
Either way, the point that agriculture takes a lot more water than people watering their lawns still stands.