For some reason this question has popped up after 5 years it was posted. Then obviously web designers hadn't blending modes such as hard light, multiply etc... They had only transparency for blending layers.
That has not prevented attempts to get something altough partially transparent greyshade texture made the colors dull as we see in older answers and their comments. With Photoshop's blending modes one would have needed a texture photo which is in average 50% grey and has blending mode hard light. The result would have been and it still would be ok.
When blending with transparency, one can add only white if the texture itself cannot be colored and the result must not become grey. A colored texture of course would work well with transparency, but this time it's obviously out of the question. If some greyness is allowed, one can simulate embossing with an inverted copy of the white texture. That is tried at the end of the answer.
White only texture cannot be right, but it can still be usable. An example:
In the left there's a not so finely painted lemon with simple radial gradient coloring. In the right there's a texture pattern which contains only 60% opaque white random dots. There's a layer mask to limit the affected area. The next image shows the texture layer as fully opaque, without a mask and against a dark background:

The texture is made from BW noise:

The noise was blurred with 1 px gaussian blur and the result got filter Stylize > Emboss:

If the white part only is used, it must be large enough. One can increase the white with curves. Blending mode Lighter color and an yellow background help to find the needed brightening:

With the magic wand one can select the yellow (=sample all layers) and with that selection delete the grey areas between the white ones in the texture. The result with blending mode normal gives the same as the previous with blending mode Lighter color:

The result is the used final texture, only remove the yellow test layer and export as PNG.
If some greyness is allowed, one can make an inverted copy of the white texture and shift it a couple of pixels. That creates something like embossing:

In Photoshop blending "lighter color" leaves the black only as edges. Merging textures and lifting the black to 50% grey with Curves generates a texture which is more plausible than the white only, because it makes the surface more bumpy. Here it's applied to a "lemon":
