Leinster have announced that Bordeaux-Bègles attack coach Noel McNamara will succeed Leo Cullen as the Irish province's new head coach in 2027.