It’s an epic renovation story that began with love at first sight but has now come to an end with someone new invited to take the reins