-First you'll need to make sure your glass is crystal clear.
-For nice shots, a macro lens isn't necessary, but you will be able to obtain much more detail with a macro.
-If you have the capability to choose how many focus points you're using with your autofocus, set the camera to use all of them. That way, it will focus on the fish wherever it is in the frame.
-Pay attention to what's blurry. If the shot looks blurry, refocus the camera and try again, don't just shoot and hope for the best. This way you can avoid the typical endless blurry photo after blurry photo routine.
-You'll probably have the best luck with a high ISO. If you have a 20D or a more recent model, you will be fine even using 3200, but 800 will of course be less noisy.
Flash setup:
--stand at a 45 degree angle to the glass.
--if you have servo capability with your autofocus, i would recommend using it. otherwise, if you have experience with manual follow-focusing, use manual.
Non-flash setup:
--open all windows, turn on all room lights, throw as much light at the aquarium as possible. however, pay attention to the reflections on the glass. you'll want to eliminate as much glare as you can. move around until you find a clear spot.
--try using time-priority, set at a minimum of 125. faster is better, but how fast you can shoot will depend upon the amount of light you have.
--again, use servo or follow-focus.
Good luck! Post your results so we can see!