The war in Syria poses the greatest threat to US security because of the risk of the government falling and the country becoming a weapons-rich haven for Al-Qaeda, a CIA official says.