If you mean what happens after, well, depending on your CTB plan and what it takes into account, the world will keep turning, and some people might be sad, but generally speaking if all goes according to plan, then i'd be forgotten in a month or two. I may pop up in conversations from time to time but it's gonna be more like "whatever happened to that guy?" kinda conversation. doesnt last very long.
For the one person that knows what happened, they're gonna be sad but I'll leave a video or something, and ask them to play it when they are sad. it's basically just me telling them not to be stupid, they have more pressing problems, and either way im ahead because i dont have to deal with crap anymore.
If you mean what happens specifically right after you've successfully CTB'd, im assuming the body releases the waste as usual, and decomposes. Again depending on your plan, the person who discovered you might be in shock depending on what position/state they find your body in. If you choose a method that leaves corpse that's...usually associated with horror (generally) like blood all over the place, then that person might need therapy but will eventually be able to shrug it off. If the method you choose leaves you looking like you're just sleeping, then it wont be as bad.
As for the police, medical examiner, funeral place people they're probably so used to it that it wont affect them at all.