The police chief of the German city of Cologne has been dismissed amid mounting criticism of his force's handling of New Year's Eve sexual assaults and robberies.