As it is duplex, the owner eats water/sewer/garbage in Cleveland

The main problem is the water lines need to be replaced. 

Currently learning the proper process and navigating the water as a new investor with barrier to entry which is why I was considering a partner.

You need to put the right number of units on the right line.You can also do a FOIA request for the water records, if that shows more units you can get it overturned. 

On top of those challenges it had on site septic and well water.

Without seams, you don't have to worry about water or urine getting under it. 

I ran into that problem multiple times where I put in a bid a few thousand less than asking price that I KNEW they would accept, only to have an out of state investors blow my offer out of the water. 

Just clear the muddy water by doing a straight up 50/50 deal.

This will not cost you anything and you will obtain 95% of your water expenses every month from your tenants.

Currently the guest house is not separately metered for water or power.