@Jamie Parker I would start talking to local banks/credit unions that do investment property construction loans once you have identified the project and have some details. Just asking about vague concepts is likely to get no good responses (banks might think you're just dreaming). You will need to big picture things like, house area/neighborhood, size, costs, timeframe etc.
I think most banks will require you hire a GC/Builder prior to closing the loan. You have not mentioned all your numbers, but if you pay cash for the land, you should be able to use that as part of or all of your required equity in the project. Unfortunately, building houses is very cash intensive.
Lastly, I personally think right now is a hard to build houses. High interest rates make the costs of the construction loans very high (~10% at a bank) and with mortgage rates so high, there is little buyers out there which could lead to long holding times. I build to rent, and currently find it very hard to make the numbers work right now with new builds in my area. In addition to the rates, material and labor cost remain very high.