These photos show how a well-thought-out restoration project can radically transform an area's fortunes