Some €1.6m has been earmarked for the refurbishment of a historic house in Cork, on the site of one of Ireland’s top free visitor attractions.