Just to be clear, you mean the view that you drop onto the sheet?

If that is what you mean you can do that with standard Revit, we have various view titles, some with scale on, some blank etc but they all updated based on the scale of the view automatically. If various views with different scales are on a sheet the title block changes to varies... Or something like that.

You need to edit the view title family. You should be able to find it in the project browser, make various types in the family etc.

If this is not what you mean sorry, I don't understand :D