I would recommend Mr. Lincoln, a hybrid tea with brilliant color and nice fragrance. Northern California is a big place, but unless you're on the coast north of San Francisco, your roses will use lots of water in the summer. Mulching helps.

Advice from a rose grower in the Redding area says that Veteran's Honour is excellent in that region.