A former Cork city councillor has pleaded guilty to three charges of soliciting to murder a revenue commissioner official, an accountant and a detective garda.