Greater Manchester’s longest-serving council leader, Lord Peter Smith, has stepped down from his post as leader of Wigan Council.