A Cork harbour town has received a major tourism boost with the announcement that it is to get a 74-berth marina.