It will be released in the following weeks. You'll be able to upload and search photos.
They'll turn it on in the mobile Apps and at Twitter.com
Are the third party image service going to die?
I guess it depends on how good this feature will be. It needs to be faster and unlimited. If so, yes, those sites will fall.