I'd avoid using a fisheye lens for aquarium photography. Especially it you are wanting an accurate documentary image as they distort the lines in an image significantly. The same is true for stitching multiple images together in a pano (shoot from a single camera position).
Here's a snapshot I just did to illustrate what a fish eye lens does to an aquarium...
Yes, I know the aquascaping is inspirational. The front of the lens was about 3-4 inches from the glass of the tank.
Yes, it's true that you can more than likely fix the distortions in PhotoShop (or the like), but it's unnecessary, extra work and why would you when there's ease alternatives? Fixing that kind of distortion in PS will result in the loss of a significant amount of image area due to the cropping that will occur in the process. And, if you're not careful with your framing when you're shooting you could loose parts of the tank in the image.
The 12 to 24mm lens you're looking at is a good focal length range but Tokina's optic quality could be better. Lens cost vrs. sharpness is something that you'll have to decide for your own application.
As far as the 3-1/2 foot depth of the tank, you won't have any problem with the really wide lenses. The depth of field is enough at the camera to subject distances you'll be at to photograph a 6 foot tank. Just keep your aperture in the mid to small range. That's going to suck for your shutter speed and or ISO though. I'd try to get as much light over the tanks as possible to help with that problem. You can check out this DOF calculator to get more specific info.
http://www.dofmaster.com/dofjs.html
Keep in mind that the perspective of your image will change depending on the focal length you use. Wider focal lengths allow you to get closer to the tank and will exaggerate perspective, making the foreground more prominent. This also gives the viewer more of a scene of being 'in' the scene. Longer focal lengths will compress or flatten perspective. Giving both the back and foreground elements more equal visual weight.
Here's an example I did for class...
90 gallon curved front corner aquarium. The camera to subject distance was changed to keep the sides of the tank just inside the frame of the image.
It's shape is something like this
Take note of..
how the curved front of the tank straightens out with the longer lens.
the difference of the underside of the surface of the water.
how the rocks & corals in the foreground relate to the rocks in the background.
17mm lens, about 4 feet from the tank
60mm lens, about 20 feet from the tank