The victim was discovered when a passerby reported a hand stretched out of a small opening in the drain