An expertly restored period property in Cobh is likely to be snapped up and attract overseas interest, writes Catherine Shanahan