City-dwellers are increasingly moving to smaller communities rather than regional cities to escape housing and transport costs, a report has found.