UK consumer confidence dropped in September as shoppers entered a "depressed back-to-school mood", new figures suggest.