If this is the path that makes sense for you I would encourage you to have the conversation with potential locations prior to starting construction.
The fact is that most of the laws prohibiting RVs to be lived in full time (most places have time limits on that, here it is 30 days) in zones other than RV parks are only enforced if reported/complained about.
The best thing to do is chat with them beforehand to get their feelings on it.
You may be surprised, a lot of people think it’s great! It’s important to note that codes/zoning/laws vary a lot by location, these are just the general rules.
🙂 What a good portion of people do is find a location, move there and take the risk that you may be asked to leave. but not that often from what I have heard from others. Ask the neighbors if they have any qualms with a tiny house neighbor.
If they do then look for a different place, that is their right.
Where to live is the one major sticking point (understandably) that prevents a lot of people from choosing tiny.