Ongoing North Korea tensions carry long-term consequences for the region, Singapore's prime minister told CNBC.