In that case, you want to change your to material’s Shading Model to ‘Unlit’ and the Blend Mode to ‘Translucent’ which will get you started in the right direction.
I believe a good example of this set up you are going for can be found within a particle system, like the impact of a bullet hitting a surface and creating the smoke effect. Below is an example of this material set up:
Hope this helps!