One of the world's leading pharmaceutical companies is to create 200 permanent jobs through a multi-million euro investment in Cork.