The outlook for the Irish economy is favourable in the short-term but Brexit is still "a big sword of Damocles" for growth, the new KBC Ireland chief executive has said.