Usually okay, if you keep it low-key.
A calm adult drink in a park or by the water is common in Berlin. Keep the volume down, use bins, and do not leave glass behind.
This is a practical visitor guide, not legal advice. Signs, staff instructions and event rules always win.