why image is not transparent
To have a transparent background you need a transparent shader.



To overlay the image on top the color used on a shader



Using the same principle you just need to add the color to the existing underlaying material, using the alpha channel to mix it.

(remember to assign the material to that part of the mesh ).