The SNP leader of Glasgow is under growing pressure to overhaul the city for the Commonwealth Games after residents told her it was 'like a war zone'.