To dream of scorpion relates to birth and death which means that the one who sees a scorpion in his dream should change some aspects of his personality and incorporate something new, totally different that he had before. The scorpion that is in the water symbolizes the negativity that is suppressed and needs to be expressed. Make sure you get rid of those unfavorable emotions and feelings. The scorpion could also signify the scars that were made by others and you find it hard to remove them. Make sure there are no hard feelings towards the others as it will cause only disruption and problems in your life. Consider that scorpion is also one of the astrological signs.
Read more about dreaming of Scorpion in other dream meanings interpretations.