Police Scotland said the man was recovered from the water at Clatto country park then taken to Ninewells Hospital, where he died later.