Former Manchester United and Real Madrid striker Ruud van Nistelrooy will take over as PSV Eindhoven manager from next season.