Once you delete a user account from PS4, the saved game data and screenshots related to that particular account will be deleted. And the apps and games purchased using the user account will become inactive. But if another user on PS4 also has the license to the material, the apps and games will remain active.