Not a true expert on the topic but from my reading it sounds like land is generally a carbon sink and water produces carbon so when you turn land into water, the net effect is additional carbon. Estimates have man-made reservoirs accounting for 0.5% of the total anthropogenic carbon emissions worldwide; fairly significant when we're considering the scale needed for energy storage with wind (blows 35% of the time, US avg.) and solar (shines 25% of the time, US avg.).

http://documents.worldbank.org/curated/en/739881515751628436...