I have a couple friends who are Catholic and Godfathers, and here's what they said.
You basically are supposed to be a mentor to you Godchild; attend birthday and school functions, help guide them in the Catholic faith, and basically treat the Godchild as if it were your own child as much as possible, because there's a chance the child may be your child someday.