The Bay Area turns green and brown every year. It has nothing to do with droughts. In the winter, the grass on the hills is green. In the summer, it is brown or "golden." That color is what the phrase "Golden Hills of California" is referring to.
BTW, it doesn't apply to the foothills, nor does it apply farther south (past Cupertino or so). So Rancho San Antonio is still brown in summer, ditto Lexington Reservoir, The Dish, San Jose foothills, etc. San Lorenzo valley is green year-round, though.