Aitken has led Scotland's largest local authority through a turbulent decade amid mounting criticism of the condition of the city centre and rising fears over anti-social behaviour.