How to show custom static content at top of each category page?

Simply call the category_description() – this displays the description that you can enter for each category that you add in the admin UI under “category” (or post tag or each other custom taxonomy).

You can as well use the underlying API function:

term_description( $category, 'category' );