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.