The man's brother is said to have followed him into the Spanish water but survived