A total of 59 percent of Canadians think the U.S. is their country's greatest threat, according to a new survey