The long-awaited Tottenham Hotspur Stadium has opened in north London, featuring a retractable pitch that can host both Premier League football matches and American football.