Deputy Attorney General Rod Rosenstein just appointed Robert Mueller as special counsel to investigate alleged coordination between Russia and the 2016 Trump Campaign.
There is basically no difference difference between a special counsel and special prosecutor. The former term came into use largely through the notoriety of the latter term during Watergate.
Both are appointed by, and can be removed by, the Attorney General or his designee, who also gives the special counsel/prosecutor his remit.
An independent counsel (IC) is a completely different kettle of fish: They are appointed by a 3 judge panel, cannot be removed by the Attorney General, and their remit is pretty much unlimited.
The law that enabled the appointment of an IC expired in 1999, following the excesses of Kenneth Starr in his pursuit of Bill Clinton’s penis. (Starr went on to become President of Baylor, where he covered up a rape culture among its athletes.)
This should be interesting.