The Confirmation sponsor must meet the same requirements as the Baptismal godparents. The ideal sponsor is one of the godparents if they still meet all the requirements (this is stated in the Code of Canon Law c. 892 §2). If the godparents have been an active part of the life of the child this is reasonable as well as practical.
Code of Canon Law
BOOK IV, PART I, TITLE I. BAPTISM
CHAPTER IV. SPONSORS
Can. 872 Insofar as possible, a person to be baptized is to be given a sponsor who assists an adult in Christian initiation or together with the parents presents an infant for baptism. A sponsor also helps the baptized person to lead a Christian life in keeping with baptism and to fulfill faithfully the obligations inherent in it.
Can. 873 There is to be only one male sponsor or one female sponsor or one of each.
Can. 874 §1. To be permitted to take on the function of sponsor a person must:
1. be designated by the one to be baptized, by the parents or the person who takes their place, or in their absence by the pastor or minister and have the aptitude and intention of fulfilling this function;
2. have completed the sixteenth year of age, unless the diocesan bishop has established another age, or the pastor or minister has granted an exception for a just cause;
3. be a Catholic who has been confirmed and has already received the most holy sacrament of the Eucharist and who leads a life of faith in keeping with the function to be taken on;
4. not be bound by any canonical penalty legitimately imposed or declared;
5. not be the father or mother of the one to be baptized.
§2. A baptized person who belongs to a non-Catholic ecclesial community is not to participate except together with a Catholic sponsor and then only as a witness of the baptism.
The Diocese of Tyler Pastoral Manual (Section G, III, B: Sponsors) echoes the Code of Canon Law.