A new sculpture to be installed in a Cork harbourside town has the potential to become one of the most photographed in Ireland — because of its design.