Andrew urged to drop Duke of York title to end 'embarrassment' for residents