There are all kinds of fruit drinks available in Mexico and they are pretty simple to make. It is just adding water and sugar to taste. This is the same as making lemonade or sweet tea. The different types of fruit I have tasted made into an agua include: papaya, cantaloupe, watermelon, orange, lime, pineapple, and cucumber (a vegetable).
The fruit is either squeezed or peeled and pureed. Then water and sugar are added. The seeds need to be completely removed from the papaya but the cantaloupe and watermelon can be pureed with the seeds. The result is then strained to remove crunchy seed particles. A pineapple must be cored and all the peel must be removed, any little brown left on the pineapple make it bitter.
The cantaloupe and papaya can be mixed with milk instead of water to make a creamy drink. A virgin pina colada is made by adding coconut milk, evaporated milk, and a little regular milk to the pineapple. If canned pineapple is used then one does not even need to add sugar.
These are all very tasty. The cooler they are the more refreshing. I am sure mango would be a tasty drink as well I have not tried it yet.