You must consider the size of any user-defined functions, methods, and procedures stored within the database when you are doing capacity planning for your system. This includes any of the UDFs you create to enforce algorithmic compression and row-level security privileges.
There are no special sizing considerations for these routines beyond planning for the space they occupy on your system.