Britain's most senior Roman Catholic cleric, Cardinal Keith O'Brien, is stepping down as leader of the Scottish Catholic Church.