If you charge him interest then no tax implication for him, you have the interest as a taxable income.
Don't charge him the interest and its a gift to him, the interest if under €3k would be disregarded as a gift.
Don't lend your brother in law money unless you are happy to smile nicely if its never repaid.