Musgrave Park is to undergo a multi-million euro face-lift which will double the capacity and transform it into a municipal type stadium.