Does this mod increase water and fertilizer consuption for farms?

No, the mod does not increase water or fertilizer consumption.

It only increases the farm/greenhouse output amount. Water and fertilizer usage should stay at the vanilla values, so the effective yield per water/fertilizer is much higher.

This is intentional — the mod is meant to reduce the amount of farms needed, not to keep the original resource balance.