There must be some restaurants around Shanghai with beautiful fish. In fact, there are nice carp in a tank that forms a sort of gazebo near the entrance to the Chinese restaurant in Le Royal Meridian hotel, IIRC on the floor below the lobby. Across the street (Nanjing Road) from LRM in the classical department store on the corner, there used to be a huge tank in the window with sharks, but that is sadly gone now.