Probably, if the professional designer understands SEO. A template site can rank okay for local searches and easy keywords. A professionally designed site optimized for SEO will outrank it for competitive keywords. The difference is most noticeable for service businesses in competitive markets.