Multiple loans

Newbie question: I am interedted in buying a multiple-unit property like a three or four plex. However, I’m sure it will cost me over 100K. I am sure that I cannot qualify for a loan to cover the cost from one place so how can I get multiple loans and it not affect my credit?

Also, what are the benefits of having section 8 pay rent. I know it comes in every month, but doesn’t that mean you have people living in your property that will ruin it?