The majority of small businesses expect revenue growth in the next year, CNBC survey shows