If you can find a free (or paid if you choose) mockup of the good you want, just use any raster editor with a transparent png of your logo and adapt the perspective.
Gimp, Paint.net, etc.
Check the licensing of the mockup files.
II. 3D Render
Personally, I prefer making a new 3D render. If you want to model the goods, a can, a bottle use Blender. You can probably find some 3D models that can be imported into Blender.
Another option is to use Sketchup, where you could find some free 3D models, and make a photorealistic render using a free renderer like Kerkythea or Yafray.
III. Conceptual art
But you could try your own style. Using the logo on a silhouette, a watercolor paint, a surrealist Tshirt... That could be an interesting option.
In that case, you could use, either Gimp again or a vector based program like Inkscape or Gravity design.