[s2671] Add script support for SSC water. Requires CMangos s1894

(based on commit 1385b30)

Signed-off-by: Xfurry <xfurry@scriptdev2.com>