Spain midfielder Rodri says it is his "dream" to play for Barcelona as he arrives in the city to complete his move from Manchester City.