If you use flash, make sure you angle your camera so that you don't get glare on the glass.
You should also wipe the glass of your aquarium too to avoid smudges and handprints from showing.
Play around with using roomlights and tank lights with a smaller aperature, or just tank lights with a much larger aperature.
I'm no pro, but this works for me.
HTH