CGI image shows how ‘unattractive’ town will be transformed