I have been to Concord Aquarium and did not really care for it. The dry goods there seemed decent though.
I have heard of "All About Fish" and I was planning on going there next time I was in the area.
Aquarium Concepts is a clean large store. They have a good selection of dry goods. Their
SW fish and corals are nice. Their
FW selection sometimes leaves a little bit to be desired in my opinion.
Octopus's Garden usually has some decent fish and some of the harder to find species. Not a lot of dry goods here.
Albany Aquarium's selection of live plants is second to none in the area. Their fish are ok. The dry goods selection is almost non-existant.
Connies Tropical Fish in Castro Valley is a kind of a strange store but it is decent enough for a look if you are ever in the area.
Wet Pets in Pleasanton is a small store that sometimes has good deals on used tanks. The fish there are ok but I have seen some pretty serious Ich there.
Pet Extreme in Livermore has a decent selection of dry goods but I would NOT buy fish there. I have seen LOTS of dead and sick fish.
Aquapet in Livermore is a dinky store that has some potential now that they have moved to a new location but I am in a wait and see mode with this one.
I have heard that Ocean's Aquarium in the San Francisco is nice but I rarely ever go to SF except for Giants games.