A large secondary school in Co Cork is to undergo a €5.5m extension which will enable it to more than double its original intake of pupils.