I really like Spring Hill Farm in Petaluma. Nice patch and all sort of pumpkin goodies using milk from their Jersey cow. The pumpkin quark and pumpking Ice cream are tasty.
Here's a good article about North Bay pumpkin patches.
It is not a pumpkin patch, but Oak Hill Farm in Sonoma had the loveliest pumpkins with different varieties.