That's highly dependent on the area it's in. Where I live, golf courses use no more water than anyone else and aren't irrigated.

The proper answer would be to simply charge appropriate prices for large scale uses of water from the water utility, or else this is a discussion about riparian rights and law and possible changes needed to that.