The latest Covid stimulus bill will help the U.S. economy roar, allowing the stock market to overcome rising bond yields, longtime bull Jeremy Siegel told CNBC.