Ruud van Nistelrooy has been appointed as the new manager of Leicester City just weeks after he left Manchester United after a successful period as interim boss