There's a DFS Galleria shopping center in Waikiki. One end of it is a three-story aquarium. There is a staircase through the aquarium (to entice you into the shops, of course). So you walk through a tube, basically, and the fish (and sharks, and stingrays) are swimming on all sides. There was also a diver in there, washing the windows, while we were there. There were some issues with glare, but otherwise they were really interesting shots.