The former Scotland frontman was left heartbroken after asking his pal to take care of his farm