well i live in las vegas and there is:
shark reef at the Mandalay Bay
at the back of the Forum Shops in Ceasers Palace
somewhere in the Silverton Casino
the Mirage has a Dolphin tank
and if you want to visit some LFS go to TROP-AQUARIUM on 3125 E. Tropicana Ave
The Mirage has some of the best aquariums ive ever seen. Also check out the rain forest cafe. As far as public aquariums im not too sure. LOTS of neat aquariums in the casino's though