Something that looks like a good thing at first, but has unforeseen bad consequences.

For instance, while irrigation schemes provide people with water for agriculture, they can increase waterborne diseases that have devastating health effects, such as schistosomiasis. (From wikipedia)

_{Major edit in body to provide a better example as requested in the comments. -T.R.}