Blender is an open-source 3D modeling and animation software. It's what I use for my 3D work. Blender can be downloaded from Blender.org. Some great resources for learning are Blender Guru, The CG Essentials, Ian Hubert, CG Matter and CG Geek.

My favorite Blender tutorials are as follows:
Real-Time Dynamic Snow by CG Geek
Projectors in Blender by CG Matter

You can see some of my renders on the Instagram.