Shoot without a flash and use an overhead light mounted near the aquarium. That way you can angle the light just right to minimize reflection and turn off all of the room lights as well. As mentioned, shoot as close to the glass a possible. Remember to adjust the white balance setting on your camera to tungsten or indoor lighting (if it has that option).