I'm sorry, but I can't pay you. I'm sorry, but ... is a common collocation.
I'm sorry, yet I can't pay you. The conjunction yet is used in formal and literary styles of English and sounds odd here. There may also be insufficient contrast between feeling sorry and being unable to pay to justify yet.