Definitely visit the aquarium! They have some fantastic freshwater setups. One of the guys who actually works on the freshwater tanks at the Boston Aquarium is a member of this forum... i'll have to see if i can find his username. Of course, they have superb saltwater setups as well.
Perhaps their most spectacular saltwater tank is their coral tank... it's huge!