Challenge a) is to get the stream. I doubt it will work with sf::Http, but you could use sockets - shouldn't be too hard, just read the content bit by bit and provide stream interface, i.e. implement the sf::InputStream interface.
Challenge b) will be decoding the MP3, because SFML doesn't support MP3 because of licensing issues.