I’m planning to give a property to my son. The notary has included a "right of return" clause. Is it mandatory?

No. This is a contractual clause and not a legal obligation. It allows the donor to recover the property if the beneficiary dies first (Article 951 of the Civil Code). Including it is optional.