The man, named locally as Simon Daniels, was reported missing after falling into the water during a paddleboarding incident on Sunday