in the process of "settling" the great person, the tooltip tells you when the resource will be connected by the tile improvement. I do that regularly with iron, horses etc with Great Artists in culture games and the resource stays connected.
However, buildings like forge, stable and stoneworks become unavailable as they require the actual tile improvement (i.e. mine etc.)