Scores of local councils have said a no-deal Brexit could result in food, medicine and fuel shortages in their constituencies – with many stating that crashing out without an agreement could lead to civil unrest and damage to social care.