"two o'clock at the water works" I've never heard of. But, exercising imagination I'd guess it means having an erection.
Probably someone being inventive with the language, rather than a long-existing slang.
Edit to add: Something about an engineering forum failing to get that one.