Rent a car and drive...about 90 minutes from SFO to the Napa area. Many places to stay, just depends on your budget. St. Helena is a nice small town with some good restaurants (most dont charge corkage as well, which is nice). I will dig up a couple of favorite wineries and get them to you, but more details are needed, how long do you plan on staying, and what time of year are you going?