Simple solutions for Brexit:
Allow Remain voting areas to Remain, and Leave voting areas to Leave. So, London and Scotland will be in the EU, Barnsley and Cheshire East will be out.
In a year's time, look at the relative strength of the economies of the various areas and give people the choice to change their minds once they realise what Brexit means for their bit of the world.