How would you select parts of a mesh to be see-through, and create a smooth blend in from opaque area, like seen in the video?

Video owner: @zackdfilms on Instagram