The son of San Francisco 49ers' legend Joe Montana has found a new home to play quarterback