Mark Rowley, former head of Met's counter-terrorism unit, to take helm after spate of scandals, including the kidnap, rape and murder of a stranger by an officer