Cardinal Keith O'Brien, originally from Ballycastle, Co Antrim, is to leave Scotland for several months after admitting inappropriate sexual conduct during his church career, the Vatican has said.