The head of Cologne's police force is leaving his post "to restore public trust in the police" following scores of attacks on women in the city on New Year's Eve, German media report.