Considering the Hotel Smolka in Hamburg?
A VT member wrote the following comment about visiting Hamburg:
The Elbe - Das Feuerschiff (Fireship) by yooperprof
Das Feuerschiff - moored at the Landungsbrücke - is an old converted fireship that has been converted to a hotel/restaurant/bar. Monday nights are an open jazz jam - a really good time!
http://www.das-feuerschiff.de/