The Healing Church Workshop is located in the Cathedral Ward. The tower is split into two sections, upper and lower. Upstairs is the Upper Cathedral Ward, and downstairs is Old Yharnam. There is another door that leads to Abandoned Old Workshop, located in the lower section.
You can find the original workshop, "source of the hunter's dream", via a drop on the wooden scaffolding in this area.