Two bodies have been recovered as part of a search and rescue operation after three kayakers went missing last night in the UK, police said.