It depends on the destination. You can't just build a bike path through Kansas and expect it to help the local economy beyond hiring people to build it. There already has to be something to attract people. If there is, however, it can be a very good idea.