The only difference is one says dell or some other OEM on it.
Neither will increase performance over the other. To get a worthwhile upgrade you need to get a larger heatsink, not one of similar size, such as the 212+ or EVO for comparison.
Intel heatsinks are better and they are easier to install you should go for intel one.
Will it make any kind of noticeable difference in my cpu heat?
I dont know what you are trying to say but if you have a choice to buy the intel one or the dell one get the intel, if you already have the dell heatsink just use that and dont upgrade.
The only difference is one says dell or some other OEM on it.
Neither will increase performance over the other. To get a worthwhile upgrade you need to get a larger heatsink, not one of similar size, such as the 212+ or EVO for comparison.