Overlay a transparent material onto an opaque material - Materials and Textures - Blender Artists Community
How to Add transparent textures in Blender 2.9 EEVEE - YouTube
Blender 2.8 How to make the texture transparent, and not the entire object, to show base color under - Materials and Textures - Blender Artists Community