Two people have died and another has been taken to hospital after a boat capsized in waters near a popular summer holiday town.