If you want to drink water instead of soda, one way you could motivate yourself is to save the money you'd spend on soda to splurge on something you don't usually get for yourself. New music? A special magazine?
Your motivation can also be more about how you feel or think. Maybe you feel healthier and more natural when you drink water.