Rules are made to be broken! No, you don't have to use soda water.
You could use sparkling water (same thing really), just normal tap water, ginger beer and more.
Or alternatively, if you're blending your cocktail with ice to make a frozen cocktail then we recommend leaving the soda water out entirely.