Veteran fixer Max Caller lured out of retirement to bring UK’s largest local authority back from the brink