Yes use a light coloured sand and make sure that you use the same colour throughout - otherwise you'll get a patchwork effect. White cement is a very good idea as it allows the colour to stand out more.
For the colour itself use cemetone dye
The most important thin is that mixes are equal gauge using a bucket. Guage the dye with a cup.