And again, I seem to have failed somewhere in my management, because about 5 years into my current fortress, everyone suddenly came up starving again. I think I may be able to keep teh fortress from initiating a chain-starve-die-tantrum-die-tantrum-die-berserk spiral liek the last one, but man are my dwarves unhappy (and hungry).
Do the animals consume my food supply? I noticed I do have some 40 puppys...
Animals don't consume food.
I'm not entirely sure what your problem is. I embark with a grower (who also functions as a brewer) that has as much skill as it's possible to give on embark (proficient.) Then I build the largest possible farming plot that I can (but just one.) Then, with my first wave of immigrants I designate a specialised brewer and allow the grower to concentrate on his growing. He would become legendary within 5 years and easily be able to cope with food requirements, provided that all dwarves are allowed to harvest and there are food haulers (otherwise the food will rot in the fields.)
The other problem that catches me out occasionally is that red menu item doesn't necessarily mean unplantable this season. It means that there is not enough time left in this season for the crop planted now to mature AND the crop will not be plantable next season. Unfortunately, there is no check for a crop to be plantable in spring when considering planting in winter, so: when you are into the last month of the year your dwarfs will stop planting and look like theya re loafing off.
Also, the unconcious dwarves setting off traps bug has been fixed in version 40d.
As to your pumps. Perpetual motion machines can be a bit pernickety, I don't use them because they are just unrealistic.
I assume you've read the wiki article about powering pumps? The key things to remember:
1) Water wheels need to be in flowing water (the way to be assured that water is flowing is to see that it is connected directly to a flowing source, like a stream or underground river.)
2) Windmills require wind to work (the way to check your wind is to build a windmill and see how much power it creates.)
3) Transfering power through power linkages (axles, gears and the like) consumes some of the power.
4) Pumps need 10 power units in order to function.
5) To avoid embaressment, build a connecting gear or axle on solid ground BEFORE building a water wheel out over the water.