Okay, I answered your original question and informed you about the proximity effect of standing close to your amp and playing at a higher volume, which is exactly how slash got the long sustain in endless rain. I also went into great detail about how a compressor works and how it can help your sustain problems. (for that alone I deserve best answer!)
Here is the problem. You have a basic line 6 amp correct? This amp already has a multitude of built in effects and amp models so spending a bunch of money on a new multi-effects pedal is somewhat redundant.
Another factor is that most multi-effects units are digital based and the compressor algorithm is very basic and does not allow you to control the amount of threshold or sustain to add to the signal (most units just allow you to turn it off or on).
Compression itself works best in the analog domain. Digital compression is something you do to software, not a guitar signal. The best compressors, with the best sound, are stand alone analog units.
I am not saying that you should not get a new effects unit, I have a very cool zoom unit that cost about $80 and has a bunch of cool effects (including a basic digital compressor which I don't use) But your original question was about getting more sustain from your existing set up and what kind of pedal will do it.
As I pointed out a decent compressor is still your best bet for that and will only cost you about $70 for the MXR dyna comp. About $80 for the guyatone ST2 and both of these units are full blown analog, and allow full control over the amount of sustain.
This would be the simplest way to go. But if you are totally set on getting a new effects unit with all the bells and whistles, then check out Zoom and Delta lab, as well as Digitech and Boss.
This may be overkill for what you are seeking though. Just keep that in mind. Don't let hype or peer pressure affect your decision process. You don't need to spend that much money to get the sustain your after.
Maybe you should take that money and save it up until you can afford a better amp.