Ireland cannot become the "collector general for the world," Irish Prime Minister Enda Kenny tells CNBC.