I've been to the New England Aquarium in Boston several times. It won't disappoint you.
My wife is from Maine. Their aquarium is supposed to be very good, but by the time we get that far north she's wanting to get home, so haven't visited.
http://www.maine.gov/dmr/rm/aquarium/index.html
Hope you'll share some pics.