well you will want to stain it over having to paint it, then you seal it, people do sidewalks the same way. when you seal it sprinkle some sand down so no one slips and falls. IMO if you have water issues would be a no no to seal it.
This thread has some tips and video that might help you:
Here's a success story about painting concrete: http://www.hometalk.com/446598/painted-concrete-floors