The best vinegar to use is plain white distilled vinegar, which is inexpensive and effective.  A higher concentration of vinegar may be even more effective, so adjust the vinegar to water ratio based on the severity of the water spots.
املأ زجاج رذاذ بنصف ماء ونصف خل.