Are water butt stands that have pieces that clip together safe to use?

Yes, as long as you fit the pieces together properly and put a suitable water butt that fits and can sit safely on top, you shouldn't have any issues. Once a water butt starts to fill with water, it'll sit on top of the stand and still be stable.