Gavin, my avatar piccy there, was taken using a standard point'n'click digi camera. I used macro setting, and flash, and aimed at the tank at an angle so the flash reflected off away from the lense, instead of straight back in. The camera was good when it was new, but that was about 5-6 years ago, so by today's standards, it ain't all that.
It takes patience, as well, to wait for the little, er, darlings, to get into a position that's photogenic.