UK consumers at gloomiest since Brexit vote aftermath as households fret about rate rise and slowing property market