I once read that mafia women most of the time were heavily involved in the business, especially during the times their men were in prison. The mafia wife that's only in the kitchen and with the children was called a mythe.
However, a woman as godfather would be impossible, cause it's all about respect and tradition, and mafia men simply don't respect a woman in such a way.