I was playing with this a while back...I never finished it but I decided it was actually very easy. All you need to do is add a column to the post table called, say, "is_pinned" and then add the is_pinned option to the composition page for staff or moderators or whoever. Then if you change the sort order of your threads to sort first by is_pinned then they will always be at the top.