Yeah, this is actually a pretty old technique. There are a couple problems, though. First, you lose control of your aperture and always have to shoot wide open, so very limited depth of field. The exception may be older lenses where you set the aperture on the lens itself. It's been awhile since I've used a lens like that, and I can't remember if it locks the aperture there, or like modern lenses, the aperture is still wide open until you press the shutter release. The other issue is I'm pretty sure you lose your ability to focus to infinity (like when you use extension tubes), and you have to get fairly close to your subject, which could be an issue for larger (and probably even medium sized) tanks.
So, not to say it won't work (I've never tried it), but you'll definitely have some limitations. If you do give it a try, definitely share your results, though. It could make for some pretty spectacular results if you can pull it off.