The man was pulled from the water at Ned's Point near Buncrana and was pronounced dead at the scene