Yes — you can do this in Lightroom without Photoshop. The most direct method is to increase local contrast on the areas where you want more texture.

Use the Adjustment Brush and paint only over the skin areas where you want freckles or fine texture to stand out. Then raise Clarity, which increases midtone/local contrast and can make details like freckles more visible. Be careful not to brush over blemishes, wrinkles, or other texture you don’t want emphasized.

For a more global adjustment, you can also add contrast with the Tone Curve. It gives you more control than the basic Contrast slider and can help separate light and dark tones so texture appears more defined.

Tone mapping can also enhance detail, but it may produce a stronger or less natural look depending on the image.

So: Lightroom is enough for this, especially with the Adjustment Brush + Clarity and, if needed, a subtle Tone Curve adjustment.