Xabi Alonso is set to become the new Borussia Monchengladbach manager, taking over from Dortmund-bound Marco Rose at the end of the season.