The body of former Villarreal and Racing Santander striker Franco Acosta has been found in a creek two days following his disappearance.