Yes, it will appear on your credit report. It will be stated as "Secured Credit Card" under Product Type.
If I am not wrong, it does go towards contributing towards your credit rating so that is one benefit of applying for a secured credit card when you are ineligible for unsecured credit facilities (as compared to restricting yourself to debit cards which do not feature in your credit report).
When the time comes for you to apply for unsecured credit facilities, the bank may give you some credit if your payment history is positive.
You should also take note that after cancelling the secured credit card, there will usually be a holding period of 30-45 days before the bank lifts the pledge from your cash deposit.