If you want to be an effective stealthy rogue, then halfling is a waste of time.
Why? Because halflings are one of two creatures in basically the entire game that cannot see in the dark. Humans are the other one.
Every other race in creation has low light vision or darkvision. And if you have to carry a candle with you, hide is damn near useless. And you're slow, so you'll almost never be able to tumble into position and sneak attack from a flank.
I'd go for dwarf or half orc (believe it or not) for a sneaky, combat worthy rogue.
Of those, both have upsides and downsides. Dwarf is slow, but has better all round racial abilities. Half orc has the speed, but suffers from the extra 'strength balancing' penalties.
And that's if you're restricted to using PHB races.
If you can get your DM to bend, just a little bit, go with goblin. -2 str, +2 dex, -2 chr. +4 to sneak, small size (but still 30ft movement). Darkvision 60ft. Still humanoid.
The best classes for multiclass are barbarian, ranger and monk. All prefer light or no armour, all get decent skill points and all add combat benefits.
Do not fall into the trap of assuming that a ranged rogue will be effective. They will almost never get to sneak attack, which is a very big part of a rogue's combat ability.