Ruud van Nistelrooy's long-anticipated exit as Leicester City manager has been officially confirmed, over nine weeks after the club's relegation from the Premier League.