You can buy textured paint for ceilings in the DIY shops , I have used it and it's ok but as topman said have it done by a plasterer , it will look loads better .
Haven't tried it, but I remember seeingsomewhere that you need to add PVA glue to the paint if you are adding sand to it - not sure why, but I would check a diy site to be sure.