Sir Rod Stewart, who was recently forced to cancel shows in the US due to the flu, has a stunning Grade II-listed mansion to retreat to