Lots of great places in Brooklyn. In Park Slope there's The Gate and 4th Ave Pub. Nearby in Cobble Hill is The Brazenhead. Up north in Williamsburg there's Barcade, Spuyten Duvel (sp?), Mug's ALe House, dBA, and of course Brooklyn Brewery. I bet I'm missing quite a few too.
In Manhattan I'd...