Tutorial:
Create Frozen Liquid Effects
link!!
The creator of this design used "Adobe Photoshop" to create this frozen liquid style in the picture. They used a certain brush style and created a 3D effect in the design to make it look like there was a liquid texture to the photo.