Jim Leyland resigns as Tigers' manager