In the early church the godparents were sponsors who taught the new Christian, usually an adult, about the faith. Later on when infant baptism became usual the godparents often took the role of guardians of the child if anything happened to the parents. Something of these two roles remains today.
Choose godparents who are likely to be around and have an interest in your child over the years. It is good if the godparents can be adult Catholics who will take an interest in your baby as he or she grows up.