The icing tip commonly used for creating cactus designs is a round tip with a small opening, usually around size 3 or 4. This allows for more precise control over the shape and texture of the cactus. By using this tip, you can create the spiky appearance that is characteristic of cacti.