Sir Rod Stewart visits local hospital where he paid for patients’ scans