Former Manchester United striker Ruud van Nistelrooy will become PSV Eindhoven manager in the summer – his first senior managerial role.