The Dive (2023) was a pretty good movie, although it's more of a thriller than horror.
The Deep House (2021) was a great supernatural horror movie about diving in a house at the bottom of a lake. Not the right body of water, but it takes place in it.