First, sorry for my English.
Requirements:
Gimp
Glass filter:
https://browse.deviantart.com/?qh=§ ... mp#/di1sio1 - Make your design what will be the colored sand. Use a hard edged brush and try not to leave spaces of the background color (or transparent).
2 - Use the IWarp filter to make waves (Filters-Distorts). Then to emulate the effect of the sand use the RGB Noise (Filters-RGB Noise). In that filter uncheck "independent RGB". After that, desaturate the color to avoid bright colors (Colors-Hue Saturation).
3 - On a new transparent layer draw the outline of a bottle using a hard-edged brush (or "Stroke Selection" if you wish) with a size of 5 to 15 pixels.
4 - In the bottle layer select the external area of the bottle with "Fuzzy Select Tool". Grow selection with size in pixels used to draw the contour of the bottle (Select-Grow). Then select the layer of sand and clear the selection.
5 - Now we emulate the effect of glass in the shape of the bottle. For that use Glass filter on contour bottle layer (Filters-Kward1979uj-Glass). After applying the filter, remove the layer of the shadow that the filter generates. You can play with the opacity of that layer, and even give it color from Color-Colorize.
6 - In a new transparent layer you make a design or drawing and apply the same steps described in step 2 to emulate the sand.
7 - To emulate the distortion created by the glass, apply a very small lens distortion "apply lens" of amount of 1.1 (Filters-Distorts-Apply Lens) in the design or drawing layer.
8.9 - In this step we emulate the glow of light in the bottle. Make a white shapes as shown in 8. Then apply a very high value of Gaussian Blur (Filter-Blur-Gaussian Blur).
10 - Complete the design. Add a cap to the bottle. Make glare, perspective shadows, etc..
I am a very bad artist (Rather, I am not an artist). I'm sure you can make better designs that seem much more to excellent real models, like this: