It is not unusual that a parent's sibling be a godparent. Since Sirius was like a brother to James, that made him an obvious pick. Although a horrible one, I would go with Aunt Petunia as the godmother. The godparent provides the upbringing and spiritual guidance of the child should the parents die. Petunia's "spiritual guidance" was repression of the magical.