You can take a go pro diving and get reasonably decent results.
There are also 2 housings that are waterproof. The one that doesn't take the LCD screen clip on and is rated to 30m and the one that does take the screen. That's 60 m rated.
For best results underwater a proper video set up is what you want but they are not cheap, and would make your eyes water at prices. ( a bit like carbon )