Sound Proofing to Convert SFR to Duplex

[Lake I.]

Hey All,

So I'm getting pre-approved for a purchase of an SFR that's perfect for a dup conversion. However, one thing that concerns me is sound proofing. Do products out there work? Do tenants care much (in my market it could go either way. Top unit would be ideal for a family with 1 or 2 children. Want the bottom to be appealing even with kids running around above it.)?

Thanks!

PS Home Depot floor sander rentals? Yay or nay?