AWS Event Source Mapping

Documentation
Blog
Example Yml:

Type: AWS::Lambda::EventSourceMapping
Properties: 
  BatchSize: Integer
  BisectBatchOnFunctionError: Boolean
  DestinationConfig: 
    DestinationConfig
  Enabled: Boolean
  EventSourceArn: String
  FunctionName: String
  FunctionResponseTypes: 
    - String
  MaximumBatchingWindowInSeconds: Integer
  MaximumRecordAgeInSeconds: Integer
  MaximumRetryAttempts: Integer
  ParallelizationFactor: Integer
  Queues: 
    - String
  SelfManagedEventSource: 
    SelfManagedEventSource
  SourceAccessConfigurations: 
    - SourceAccessConfiguration
  StartingPosition: String
  StartingPositionTimestamp: Double
  Topics: 
    - String
  TumblingWindowInSeconds: Integer

Destinations are only a feature of asynchronous (Event) Lambda invocations and those from stream sources.

On any asynchronous function invocation (not stream sources, more on this later), you can set a destination for onSuccess and onFailure.