A murder investigation has been launched in County Cork after a man in his 60's was shot and fatally wounded in Fermoy overnight.