On top of that, hiring tribal members for construction or operations could qualify for employment-related tax credits.

You could look into forming a C Corp as an alternative way to own this property that could affect your tax returns differently, I am not a CPA or giving tax advise.

And you now have to file three tax returns:- partnership tax return- your individual tax return reporting 1/2 of the partnership losses- your partner's individual tax return reporting their 1/2 of the partnership lossesAnd while partnership return can be DIY-ed, it probably should not be.

There are also additional costs of operating and maintaining an LLC, like separate bank accounts, annual report filings, tax filings, etc.2.

I am looking to purchase real estate for both investment purpose as well as to offset as much tax liability as possible. 

Taxes: Be aware of potential transfer or capital gains taxes, depending on your state.4.

Would that lower our tax liability from other income we receive or no because this is purely RE and not an operating business?

In that case you might save taxes building with them.

Explore the possibility of doing liability insurance instead, if you don't have much equity it may be your best, and much cheaper option.  

The use of the accelerated depreciation strategy helps real estate investors to reduce the tax liability immediately which therefore increases their bottom line due to the offsetting of income.