It always seems the polite thing to adopt the local pronunciation, however strange. But when it comes to a situation where late comers have mangled the way an existing name is pronounced I'm not sure what's the right thing to do. (For example kat's example of Mesa Verde - or in my part of the world Sawbridgeworth, which used to be called Sapsworth, but now tends to be pronounced the way it's spelt.)