Chiefs coach Clayton McMillan will take up a three-year contract to lead Irish club Munster as the permanent successor to Graham Rowntree.