Sonoma is roughly a 1.5 hour drive from San Francisco International airport, taking the scenic route over the Golden Gate Bridge and through Marin County. An alternative option is to fly into Oakland International airport (located about 1.5 hours away from Sonoma by car.) or Sacramento International airport (located 1.5 hours away from Sonoma by car). Renting a car is recommended in order to discover all the beauty of wine country.
The city of Sonoma has a number of small inns or bed and breakfasts. Nearby Napa (30 min scenic drive) has a larger selection of hotels to choose from (Napa+Sonoma=best of both worlds).
Options for both Napa and Sonoma are available on VRBO or Airbnb.