In my InDesign FX course at lynda.com I have a movie on how to create an embossed leather effect.
It makes use of the Bevel and Emboss feature, and a little careful attention to match the highlights and shadows in the underlying image. Check it out in InDesign FX.
Not a lynda.com member? Get 7 days of free unlimited access to lynda.com.