Hello, I reside in the greater Sacramento area now, but I lived in SF for 14 years and the Bay Area for 23 years. I still travel to SF 6-10 times a year (to see friends, shop, eat great food, etc.).
You will find a fair number of Celts fans there, but I've never known of any "hangouts" specifically inhabited by them.