Scotland could learn from local democracy in France where a large majority of people have confidence in their elected representatives