The famous Marina riverside amenity in Cork has been earmarked for a multi-million regeneration to create a new promenade.