A new hospital is urgently needed in Cork, the head of an advisory board that drove a major health reform project has told an Oireachtas committee.