Is the Siteplan A Callout from something else? If not you'll have to trick Revit. You take the Site plan off of the sheet, Make a callout, then Rotate the callout boundry. This will rotate the view on the sheet, but leave the view title at the bottom where it belongs. It's a minor pain, but it works.