@Ryan McGlasson, if you wanted to put a deal together, you would have to bring something to the table. If you have no liquidity, net worth or experience then your best bet is to find a deal that realistically makes sense and take it to a proven sponsor with the track record necessary to take it down.
You mention getting a non-recourse loan. Typically to be able to qualify for one, your family member definitely would still need to qualify. Does he/ she have experience and a track record with multifamily, specifically with non-recourse type loans?
If your family member has the liquidity and net worth required and you are able to find an opportunity, you would still need to meet the lender requirements as far as a proven track record. Again, this all comes back to building good relationships with sponsors and if/ when you find a TRUE deal, you can leverage their experience and move forward.
And to answer your question. Yes, you technically would be a co-sponsor if you signed on the loan with others on the GP side.