As he publishes his memoir, the celebrated DJ tells Des O'Driscoll about the Hacienda, M-People, and his visits to Cork