The former Aston Villa star is set to become a Bluebird on the final day of the January transfer window