The people building it come from out of town, the people who will be making money from the pipeline are its owners, and the people who will be picking up the bill if things go pear-shaped will be the people who live there.
If you have any doubts about that, check out how the Exxon Valdez spill was handled. The oil company makes the profits, and can find all sorts of ways to get out of paying for the damages.