A new economic sentiment survey paints a mixed picture on how small business owners are thinking and feeling about the future.