A centuries-old tower in West Cork, in a semi-derelict state, will open to the public this summer as a tourist attraction.