From the airport map on its website: the drinking water dispenser is opposite gate C07. https://www.hamburg-airport.de/en/guide-explore/airport-map