I have heard
Browns Brewing Co. is worth checking out. I personally have not been, but have been told it's quite good.
Another place that I KNOW is worth checking out is
The Man of Kent.

Great beer selection, Great food! It's in Hoosick Falls, and
is a MUST!
As for the pump station.
From Troy take 7 west over the river
Take 787 South to Exit 4B, Clinton Avenue.
Turn right at end of ramp (Broadway). You can see it fromthe exit ramp.
Take next right at Spencer street (Progressive Insurance).
End of street take next right into parking lot of the Albany Pump Station. It's pretty much tangent the overpass
If you can only get to one place, go to the man of kent!