The Grade II-listed building has led many lives, from acting as a hospital to being home to a rock star guitarist