Three people have died after a family encountered difficulties in the water off the coast of Shoreham-by-Sea, prompting a major emergency services response.