The place to be is along the river. You can't miss it. Try the beach bar on the "Rechtsrheinisch" (right side of the river).
The stadium is some way out on the left side of town.
Cologne is a cool, civilised town, enjoy it.
Send your feedback or queries to firstname.lastname@example.org