Should I purchase a house by a creek?

[Yinka Taiwo]

My offer has been accepted for a potential house hack house in Stone Mountain, 30083, of Atlanta GA.

However, I just realized that the backyard leads to Indian Creek (a creek).

What are the pros and cons of purchasing property by water or a creek?

As a visual, the house has a circular driveway in front that's lower than street level and backyard descends from the house into a creek.

One con is that I'd likely need to carry a $2.5k+ annual flood insurance. Anything else to consider?