In order to get the steerage and propulsion in the shot, I suggest visiting when the tide is going out and between 2 and 1 metre (see https://www.tide-forecast.com/locations/Hamburg-Germany/tides/latest). Lens range is anything between 35 to 200 mm depending upon your composition.