California's big cities tend to come in closer to Melbourne, or, in some cases, lower. The water districts cited at the top of that L.A. Times article cover huge areas, not, in most cases, individual cities, and some of those numbers likely do include agricultural use (not to mention golf courses and other questionable uses), despite the way they are presented.

It's weird that you're using both higher and lower population density ('more agriculture') as arguments for legitimately using more water. Also, I'm not sure if you know that Melbourne also has plenty of agriculture within it's city limits, lots of market gardens, and some farms out east. As for golf courses, Melbourne is somewhat known for it's "sand belt", an area full of golf courses because land is crap for anything else[1].

But no matter how much hand-waving you do, there's still only a couple of areas in California use as little water as Melbourne does, none use less, and plenty of it uses much, much more. Compton uses nearly 50% more water than the Melbourne average - where are it's agricultural industry and golf courses? Beverly Hills uses more than four times as much as Compton, and it has no agriculture or golf courses either (though it is next to one)

The point is that Melbourne is a perfectly workable city, and it gets by on a fraction of the per-capita residential use water that Californians do. Californian residents consume a phenomenal amount of water.

[1]http://en.wikipedia.org/wiki/Melbourne_Sandbelt