An off-duty police officer has drowned in a tragic diving accident at Mettams Pool.