Putting in a pool can be a smart investment for some homeowners, but it also requires significant upfront costs and ongoing maintenance.