Houzz Pro is a lead marketplace and project-management tool aimed at the design and remodeling trade specifically - it can generate real leads, but like other marketplaces, you're paying for access and sharing the homeowner's attention with other listed pros nearby.
Your own website is the asset that compounds - every piece of content, every review, every ranked page keeps working for free long after you've paid for it once. The strongest setup most remodelers land on is running both: Houzz Pro (or a similar platform) for near-term lead flow, while local SEO on your own site builds toward a lower cost-per-lead over time.