Summer surge in Scottish footfall stalled in August