Collingwood Football Club President Eddie McGuire has announced his resignation effective immediately, ending a more than 20-year stint as the Magpies president.