Can't say I've been to any great ones in Brooklyn. Manhattan aquarium in manhattan, and absolutely fish in Clifton NJ, are probably my favorite stores in the area.
China Town has a bunch of fish stores. Manhattan Aquarium on the upper west side does mostly salt water/reef. Used to be several out on L.I. but it has been nearly 15yrs since I was in NYC.