Best parts to stay in Cologne is the gay area near Rudolphplatz, where many of the gay bars are located. Everything like restaurants and the big shopping street is on short walking distance.
The other popular part is the old city, more close to the railway station and famous Dom cathedral.