Leinster have confirmed that Bordeaux-Begles assistant Noel McNamara will succeed Leo Cullen as head coach after the end of the current season.