I don't kow any cameras which are completely water-proof that you even could dive with them.
Of course, some of the smaller cameras are able to, but I think of the big SLR's. For these you can buy underwater housings, which almost as expensive as the camera itself ;)
!BEER