The U.K. economy will be negatively affected by the country's vote to leave the EU, according to a new CNBC survey of chief financial officers.