I also have an '06 330i ZSP. My water pump never died but was replaced at 139K at the same time as the thermostat, after the T-stat threw a code on the way to a track inspection, prompting me to deal with it right away.
'11 BMW X3 xdrive35i
'05 Volvo XC70
'05 Sienna XLE Limited AWD
'06 330i (6MT, ZSP, ZPP) (retired)