A lumbering giant will today be unveiled as the newest attraction at Cork’s top tourist draw.