I'm not a local, but I end up there about once a year. City Beer is a cool little bottle shop and tap room that's not far from you. Toronado is a bar that usually has some good stuff on Tap. If you've got some time take the BART across into Berkeley and go to Jupiter or Falling Rock (both...
It should be fine. Any pumpkin remnants should drop out in the primary, when you move to secondary or the bottling bucket it should stay in the primary. Being that it's been in the wort/primary longer the pumpkin flavor will be stronger than if you removed it with the grain bag.