A major council has backtracked on a local law and made it a criminal offence for homeless people to camp on public land.