Leicester City appoint Ruud van Nistelrooy as their new manager following Dutchman's release by Manchester United.