The asset management firm Standard Life is looking at Ireland as its European base for when the United Kingdom leaves the European Union, its CEO told CNBC Tuesday.