Pretty much any type of cucumber for eating will work for cucumber water. Try mini cucumbers, English cucumbers, or your regular cucumber. Just don't use pickling cucumbers because their skin is super bitter and the flesh isn't flavorful.