Here is the Stained Glass recipe I built for my personnal scene, the Hero Tomb.
I basically draw my design and cleaned it in photoshop, move to Designer when I used my drawing as mask to drive surface sculpt. i also created specific Bank materials like Dust, Lead, Melted Tin, iron and Glass I then blend together in Painter according to textures I generated in Designer.
Here is the Polycount thread :
http://polycount.com/discussion/185468/the-hero-tomb#latest