Buying a house and renting it out makes little sense with the increased interest rates. Let's assume an investment of 500,000 (i.e. purchase price, incidental costs, and minor cosmetic repairs), then the interest cost alone would be 20,000 (at 4%) without any maintenance reserve. For this to be cash flow neutral, the cold rent would have to be easily 2,000 euros. The OP would also have to pay that with a purchase (plus repayment). But here he is willing to pay an irrational lover’s price to "own" property.
A financed real estate investment currently only makes sense if you expect future price increases. If you only look at the ongoing yield, you are committing pure stupidity. At least the owner-occupier has the consumption of a large living area. And the speculation on price increases can only be realized by the OP if he buys himself. Otherwise, he would at best get this yield as the sole heir, but even then his wife would have nothing from it.
At 2,000 euros (or even more in the case of renovation backlog) cold rent, the OP would probably quickly give up on the house and prefer an age-appropriate 2-3-room apartment.