Creative Architecture
AquaDom @ Radisson SAS hotel, Berlin
One of the hotels that you can specify an indoor facing room. There is a bar in the lobby where I took the photo so you can stare at the fishes with a drink in hand. Also can take an elevator up the centre :) Details of the hotel here
