In your dream, the presence of water can symbolize various aspects depending on its context and representation. In Islamic tradition, water is often associated with life, knowledge, and purity. Here are some insights based on traditional Islamic sources:

1. Symbol of Life and Sustenance (ماء - Mā'): Water is essential for life, and in dreams, it often denotes sustenance, mercy, and blessings from Allah. This aligns with the Qur'anic description of water as a life-giving source (Qur'an 21:30).

2. Dual Nature: Your description of the water being both frightening and peaceful reflects its dual nature. It can indicate internal conflicts or emotions you might be experiencing—fear and tranquility, struggle and peace. This suggests a period of personal growth or spiritual reflection.

3. Interpretations of Water: According to scholars like Ibn Sirin, clear and pure water in dreams is a sign of prosperity, happiness, and health, while murky or stormy water can represent difficulties or emotional turmoil.

Personal Interpretation

Considering your description, Allah might be guiding you to focus on finding balance in your life. The peaceful aspect may be an encouragement to trust in Allah’s wisdom and mercy, while the frightening aspect could be a reminder to stay vigilant in your spiritual and personal life, seeking clarity and resolve in facing challenges.

Spiritual Reflection

Reflect on your current life situation. Are there areas where you feel conflicted or uncertain? Embrace prayer (صلاة - Salah) and seek guidance through Istikhara (إستخارة) to find clarity.

May Allah guide you through this journey with blessings, ease, and understanding.