Brooklyn Aquarium! We have the conservatory pass so it's free, heehee, used to go there every other week or so, and the beach is just outside! Frank from Frank's Aquarium works there too, lol.
The Bronx Zoo has some giant gouramis in the Asia Exhibit XDDDD I spend a good 20 minutes just sitting watching them every time I'm there.
"Heee-eerree fishy fishy fish!" -ernie