A US mayor who allegedly roamed town hall with no trousers on has retired after months of public outrage and a vote of no confidence