As the government launches the biggest shake-up of local government since the 1990s, Sean O’Grady looks at how likely it is to change things for the better