How can I overcome my aquaphobia?

Therapy. Please remember that phobias are irrational fears and not a sign of weakness. You should seek counseling. Phobias are treatable.