Leicester have appointed former Manchester United striker Ruud van Nistelrooy as their new manager.