This already happens as part of the water cycle. It's not really anything new. People won't actually be drinking urine they will be drinking water taken from the urine so it makes no difference. Many countries reclaim water from sewage and do the same.