Cats typically dislike COLD water, not water per se.
Angel's advice is sound. Remember that cats like elevated perches, and countertops are often the highest places in an average home. If you don't already have a cat tree, get one. Your cat should be drawn to the cat tree's height and may abandon the countertop for the higher cat tree. During the transition process, use the squirt bottle technique.
