Seems very restrictive and would deter a lot of guests. 

There's < 2 months of seasoning for the purchase, cash into the deal is ~$975k w/o rehab (minimal planned so far - turnkey), purchased the property for 35-40% below assessed value, 825+ FICO, and would optimally like to pull out $975K-$1.15M of equity.Main scenarios we've thought of to accomplish this are: 1) structure sale of property from SMLLC to self and secure 30-year new purchase financing on deal (unsure if legal and tax implications if above initial cost basis)2) delayed financing (LTV restrictions a concern)3) cash out refi (seasoning concerns)4) DSCR (seasoning and rate competitiveness concerns)5) one of the above plus a HELOC, personal loan, etc.?

I know there are some restrictions on short term rentals (1 month min.) in the area but I believe even doing 1 month rentals at a minimum, the financials of the deal still work.

So, Atlanta passed STR legislation in March 2022 that was very restricting.

Above 5+ units is possible but more challenging and rates are where you would expect them..50-65%LTV will be common for higher plex units, a common workarounds is if they have a US based family member or business partner with an LLC..Some investors or lenders have specific countries of origin that are restricted or even prohibited, check with your mortgage professional. 

Such as minimum ceiling height, exits, window amount and size, etc etc.  

I am currently assisting an investor out of California with a flip in University Heights.

Are there any zoning restrictions in terms of what businesses can operate there? 

The drawback you have to fit "in the box"; 20% down +, excessive reserves requirement, specific restrictions on tradelines, assets guidelines, DTI under 43%, owner occupancy etc.. if you are open to ARMs you will have a bit more options..Also need to consider the type of property - if condo/condotel banks might not finance at all.. there are many factors to consider we do have some good outlets for jumbo, would be happy to review your scenario and give you a quote.

Too few details to answer (Of course this varies county by county, all questions could be answered by reading the (zoning)/building code and/or clarified with a visit to the county planning office).but some clarifications because: lots of things are "tiny homes" but what you describe small houses "on permanent foundations" needs to be clarified , tiny homes could be:-stick built, see below. check your county code/planning dept-stick built cabins/recreational, a specific zoning and potential occupancy/etc restrictions but worth looking into where the zoning allows for it -hud manufactured homes (smaller singlewide perhaps 400sq ft 600sq ft minimum)-non-hud park models (on axles), ansi standards- other "RV's" built on a chassis:  organizations, state agencies, etc - will certify factory built (or sometimes inspected professional built) tiny homes on chassis - to whatever standards ansi, riva, dot/ l&i?