Councils warn of post-Brexit 'perfect storm' in rural communities