Warning from County Councils Network comes as the government already faces a backlash in rural areas of the 'farm tax'