Where do I get the keys to the doors in the mayor’s house?

You can get the keys by completing quests. The lockpick you have in your inventory won’t work because it was made especially for the town gate. In the mayor’s house, you’ll need a new set made by the mailman, but only as part of a quest.