In summary…

The tiny milk particles in the water offer a reflective surface, so as the light enters the water it bounces off the white particles in different directions, which is how we see the light beam. The coloured cellophane filters out all other colours, so you see a blue or red beam.