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!